Subscriptions.BILL_DATE = 10/01/2001
Subscriptions.BALANCE <> 0
Note: BILL_DATE corresponds to the Run Date field on the Process billing window (from Billing, select Process billing). Make sure to consider whether the Run Date was overwritten.
If you select the Calculation mode, entering the following calculation expression on the Comparison Value window verifies that the Bill Date matches today's date.
from Name,Subscriptions
where (Name.ID = Subscriptions.ID
and Name.MEMBER_TYPE = 'M')
and Subscriptions.BILL_DATE =
'2000-03-06'(Specific date)
Example of the Comparison Value window.
If searching for multiple customer types, use the following command sequence:
From Name,Subscriptions.ID
and Name.CUSTOMER_TYPE = 'M'
or Name.CUSTOMER_TYPE = 'CM'
and Subscriptions.BILL_DATE =
'2000-03-06' (Specific date)
Caution! Any ad hoc search instruction must also include any filter that would already be inherent within the cycle and renewal printing process (for example, specific customer type and/or categories, printing flags, and specific products).
10.6 Production Release. Updated 9/7/2005 10:24:42 AM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.